SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4771 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4771 [ RunTime:0.002177s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109077,36340,628383,196687,767689,846114,542355,471213,549318,58225,70120,578908,999827,804869,943637,356207,962708,507106,401897,725442,823015,142262,305010,330703,465590,295759,149999,219801,953470,754343,16650,325636,210157,813701,864004,897346,1043598,114307,673101,827413,257135,312134,902411,292738,107872,872201,99293,4877,441776,642911,1006234,755745,71381,866403,424767,867133,246061,358765,1035508,839510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002931s ]