SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681441 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681441 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003368,269888,3364,948334,599710,393209,50077,670104,87874,958065,145188,629661,105470,382723,568832,866696,821186,303140,540566,295866,116783,711348,787265,312668,928181,376183,996759,754524,331739,835075,971276,640886,266749,757924,1025238,855245,14341,975803,385019,492810,314301,658862,147339,1044156,644914,159682,49554,939341,967203,745779,835310,885913,662127,624673,572764,761390,858290,614549,817058,474142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]