SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041780 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041780 [ RunTime:0.002575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707210,316932,499391,777980,255410,1011046,479132,173975,870297,614222,215391,973883,781520,1031167,529860,419688,182489,985246,653416,67100,729811,382469,871172,720940,1040895,327928,655949,320808,511277,976553,819389,912837,123446,577528,157905,171656,1014344,594277,689760,269805,325223,406421,315793,594941,438647,46274,799324,187769,1016959,112772,55375,1004699,832497,818747,848357,183366,666392,939403,1001249,12056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]