SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001742s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 615023 LIMIT 1 [ RunTime:0.001582s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 615023 [ RunTime:0.001427s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036548,393675,383093,317474,345405,840692,594896,419771,438506,346761,681567,111967,204458,900891,649519,746294,513344,1040597,259085,697812,251145,59555,84512,862676,979243,85652,469759,77620,252052,377764,651150,819115,850902,331442,930500,604966,488765,914789,764512,855419,238185,991314,338627,1013700,970768,234784,380147,752543,503558,504447,15867,794805,120089,610252,109007,246760,1028799,481321,614919,124134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 615023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 615023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]