SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508893 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508893 [ RunTime:0.001437s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (322145,254675,1025105,642547,40224,778594,827988,884688,105378,582599,805780,710228,1041542,418983,442517,577584,750727,69005,115863,468762,200958,151755,972005,584975,721173,178434,541478,355782,784631,240312,280710,973022,640108,712529,35278,942123,504353,927595,922094,277160,773783,278719,531612,516359,229540,542310,437356,367625,886881,510991,248929,494460,596357,190694,984251,915596,233222,40737,718661,702311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]