SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 884401 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 884401 [ RunTime:0.001743s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993415,392808,482342,909115,983676,441616,893055,1028020,451193,621698,692521,971845,307596,263446,303669,279873,788280,421252,842108,370045,875212,14147,936987,722412,78712,844847,518481,987075,41259,483717,998267,696105,550951,287040,623477,889920,605348,36343,432726,1025794,1045628,852579,22995,171443,135748,213568,275219,665114,625652,908087,386191,411530,56443,192776,628068,177951,785989,588668,730638,954041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 884401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 884401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]