SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021787 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021787 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819202,732298,322758,657849,82274,744356,501785,38498,472824,165485,645668,527713,579231,730219,247420,884530,1014059,1024755,474563,614794,894973,612381,374660,841673,561096,208980,99546,336350,562639,836458,741108,1023600,899434,879498,700101,705549,141635,954603,664463,896261,867525,497233,529919,545041,430479,124985,983144,812679,989596,530153,638539,818758,396967,452669,985492,666511,575889,3608,111978,529845) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]