SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493594 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493594 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (327095,269662,1041376,1001357,752195,429488,898386,237948,114741,232431,80569,839576,408181,19159,927943,53067,1004611,1014472,437546,152892,281970,427670,936652,251601,995499,819102,791791,337418,668201,956620,470003,193776,559504,419398,543595,320879,668297,187922,198205,661984,816460,403324,1004411,128870,320214,583693,836659,456650,274369,951406,792920,364325,594787,864838,605421,29722,912609,970600,720435,27129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493594 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493594 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]