SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001922s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807213 LIMIT 1 [ RunTime:0.000985s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807213 [ RunTime:0.003172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353594,585867,113648,350783,974005,285542,609923,368117,173734,800919,383254,289012,981717,211126,531180,775175,813502,67945,335942,394029,164160,1001585,850533,496974,915730,67442,393932,567658,754184,990472,475321,191806,244019,73429,546395,612032,216318,602096,575639,600072,176598,370102,701902,482256,582721,501437,596307,230566,758084,84483,539908,519548,990165,219294,911637,210905,92603,151318,413492,90747) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002919s ]