SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511349 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511349 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105336,299314,1028388,967639,718011,1002593,597181,238847,24724,3786,414387,544452,618196,965747,78062,486265,627746,456890,832108,395928,835643,1001010,598603,216755,248273,422197,1024629,982632,513139,965282,105283,375232,388684,823340,405141,170526,568643,839864,64943,531918,560538,755625,648227,18809,922808,454023,754713,229849,55147,36682,336100,1033517,193240,306004,1020747,308292,334157,706380,950792,980293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511349 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511349 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]