SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428185 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428185 [ RunTime:0.002066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (604382,949163,684095,243495,257740,94489,174955,835464,401748,315183,1046165,68464,179823,733346,144753,245421,958304,289124,141396,995829,848020,523191,691960,11180,655291,999033,646889,278947,231198,18387,276032,259241,198686,454890,458074,319758,241357,619796,226561,355566,435310,34578,263295,687689,390450,1030573,1010461,167142,461714,847994,27830,791280,282004,394075,630370,613699,1016691,746774,280903,716400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428185 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428185 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003818s ]