SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002805s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146103 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146103 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407894,486287,848505,661205,741436,584599,781563,1023814,498754,367989,941994,78024,142779,427827,834761,242105,838766,378447,769181,279493,218970,464602,10742,868285,1048051,993789,391677,743461,995399,765139,431379,742218,321366,909683,71084,252055,943151,135460,438185,654856,1025246,724793,26824,83726,795637,37878,234760,413895,81969,163987,993078,864875,470924,158368,679542,436931,313556,523493,652069,503916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]