SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424782 LIMIT 1 [ RunTime:0.001237s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424782 [ RunTime:0.001999s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038581,960679,197698,785706,1036532,630376,927918,975291,897665,404044,659485,1043648,360999,242529,480573,360105,870544,61039,971607,1000869,11503,501926,538889,981044,349689,179741,1014487,551388,263164,603237,262799,799530,884632,284457,1041658,157021,491894,894882,299386,1044229,571084,442969,6258,347118,878740,394135,557247,457323,404139,115910,241439,482000,42552,974711,1002131,295152,581168,486996,643326,236938) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424782 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424782 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002903s ]