SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533280 LIMIT 1 [ RunTime:0.000795s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533280 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (623540,253357,612531,571927,40437,792959,397107,216314,852904,423643,436651,569896,284003,346719,554668,441912,237468,849515,177294,593236,379068,452788,375234,322843,1014275,645851,712014,1033677,710117,689635,135172,495537,102948,238261,607260,878193,242112,579155,374940,440993,494050,490931,533323,732322,782462,724838,504670,465733,436308,987066,283224,574582,938892,30931,729180,586883,418307,743564,921343,347866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]