SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409101 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409101 [ RunTime:0.002495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (949914,533721,460899,840824,787431,368038,1010076,509898,72163,632189,772935,865195,459740,157395,656106,705738,824720,154668,907677,229709,651585,858091,481740,254766,558500,170424,432145,260318,867613,456654,91046,238262,111073,200850,567483,339617,142998,298826,856161,430831,843236,500870,147336,852795,428342,251044,701471,1008894,25539,975026,554586,156830,531473,203618,592927,448994,350900,171611,441254,888318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]