SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004145 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004145 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314630,450362,756706,811085,201180,74379,697057,37773,740903,1036116,745299,706710,694764,374905,943508,414736,788770,918758,552231,849673,133741,901254,447702,903431,240815,636141,844533,660614,500697,977466,703077,962787,359232,212184,111092,63581,541205,892500,189150,230802,396179,618560,129728,234324,486775,375459,398698,424604,909194,1023541,575650,440759,585405,159348,223169,1006077,235733,590086,595396,544583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004145 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004145 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001336s ]