SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 148096 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 148096 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535240,231387,410900,252499,773410,988016,179412,876603,2767,346911,885001,910739,871769,908002,860200,68331,924290,902691,482883,710339,594417,476280,56580,952773,959935,580800,245448,579713,97115,395147,1042027,738715,41160,513994,1006950,88439,121497,151967,731721,297745,1040986,630972,449539,381149,350445,16261,654423,444677,208924,69548,235647,132954,171028,420353,231025,463097,761485,356284,93161,385658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 148096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 148096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000937s ]