SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526593 LIMIT 1 [ RunTime:0.000714s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526593 [ RunTime:0.002489s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733382,333162,721355,146358,544931,917821,166655,204043,747150,667507,849862,979888,392741,302043,604760,569323,246938,112033,374051,747472,731928,601840,1041334,323223,689353,942224,6676,378211,546325,950816,237627,987726,102411,552726,785466,662647,217780,962965,406958,423834,880751,41631,356630,279955,247879,721130,616652,599876,324125,628612,474864,886448,1005017,368092,926460,233629,476741,953712,533373,324776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]