SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560968 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560968 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269369,846194,676956,872757,252920,785843,592712,871220,383559,748766,428944,624305,287525,429957,295914,787060,780477,833517,294318,1003823,6865,258364,32921,173300,122348,887305,748524,379536,340845,270803,552584,75651,1001215,993478,870728,87565,460581,162814,148802,929563,139232,153947,999864,272885,350232,900941,351388,148669,1039960,957052,476810,66913,127466,108800,265417,5996,1002944,993648,686345,461111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]