SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479952 LIMIT 1 [ RunTime:0.000491s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479952 [ RunTime:0.001661s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (948442,1044067,817689,166365,540413,724445,741524,807281,996815,667506,13550,736279,319048,526818,466564,384085,181943,273403,128724,967284,553770,370468,326774,362934,126069,286441,765683,116401,690075,844504,208247,193625,158613,740885,938484,757371,555785,78403,79058,728308,263019,959317,1029111,63221,607093,653416,682484,370117,667821,905386,101718,241133,983914,630791,181686,767179,235085,1028934,895061,797224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]