SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407879 LIMIT 1 [ RunTime:0.001045s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407879 [ RunTime:0.004294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482384,341352,1013104,550050,738055,1038248,116867,638284,497830,525044,801366,275481,960728,699434,556672,823854,186503,877464,323563,836259,398789,694733,434908,1041624,563068,653013,756144,164592,802942,582073,865838,917956,352589,680894,219501,817470,997760,861838,822816,469495,541049,281130,639624,810956,89269,703793,901409,337114,639969,792940,16536,545820,688693,214803,433590,31659,75184,903183,463442,218193) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008933s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407879 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407879 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001192s ]