SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262503 LIMIT 1 [ RunTime:0.002762s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262503 [ RunTime:0.005908s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016300,442638,137551,149131,685699,624175,716129,119062,195619,599631,568013,344716,489735,1028675,314730,779500,361348,422791,436791,205875,903939,772444,928054,897909,742119,361166,185145,823139,969754,383023,282935,559207,91861,54217,797001,732916,206942,481356,781514,693766,256715,191927,636600,845783,786629,182217,232648,32845,919260,788811,72554,182392,325765,131220,11840,1028551,966567,661978,294940,433760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001675s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003661s ]