SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144414 LIMIT 1 [ RunTime:0.000540s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144414 [ RunTime:0.002108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417258,526450,871081,715105,775788,141381,518948,742877,349959,472624,563137,568907,908409,584316,146020,476829,78900,406540,507699,478115,1044632,970423,1022730,900220,325279,669535,23540,112965,889520,835475,932401,832557,518788,1010974,469984,161258,955958,346240,663116,159908,569758,710889,681473,841461,829843,801146,471808,598457,750960,613294,720632,246002,528738,582,670418,407595,125025,430807,101289,816642) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]