SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402641 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402641 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399269,914492,649540,9915,420802,1030823,27896,174472,438457,959272,192387,825893,866883,409026,362571,207709,802669,818941,339423,193199,656568,77421,712660,123571,655827,304499,834277,602959,93753,656003,377155,185124,483042,896425,403806,537254,949019,971766,1014965,807670,427705,1020310,919554,70372,251054,319718,508317,336006,1006655,985561,983891,673657,486913,481452,191893,1001986,440343,312508,806916,602885) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]