SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416887 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416887 [ RunTime:0.004012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576259,930731,126289,616408,340644,211435,425925,202143,823000,1040217,1036550,533377,96885,708027,855464,984142,1012264,49371,715584,982256,595370,812886,774815,1003985,712728,571979,990842,1020044,523354,541803,171280,631531,1007311,318759,13537,985759,710006,993758,114396,283905,896581,606091,930210,1014096,475740,342448,795700,693075,764535,104730,401822,1008383,327431,982857,130444,741389,648450,213853,392338,129274) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]