SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 235100 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 235100 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45214,427742,1015418,724002,572104,703132,553384,433404,1020930,220832,891625,521950,147734,434597,1015155,875789,91466,882635,28895,711962,810598,77834,992473,1023649,104333,503443,625404,521870,472339,660307,208062,126997,7118,1040405,54934,71864,36322,440935,364189,226810,874041,682607,263392,226749,953938,533439,585571,138077,348479,764986,843682,357814,1033931,970793,375747,606753,1016711,179367,29342,925628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 235100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 235100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000705s ]