SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403776 LIMIT 1 [ RunTime:0.007323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403776 [ RunTime:0.004174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847611,698407,360692,702347,613943,429834,988074,979570,279503,543166,423215,186036,306673,988343,1041660,517873,69679,877354,876485,199402,710913,569373,676110,578750,572372,11888,399794,967078,968004,561782,272841,430390,205699,39966,292325,443553,201511,863152,300085,195753,50482,613623,763591,907848,21986,453614,844991,12103,272071,217218,244099,752439,286522,314775,109703,610971,495200,419375,249532,815099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.031694s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]