SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28139 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28139 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663151,82105,314014,18524,117518,682957,875056,364776,358388,47787,471975,196064,255509,929788,864063,340429,174457,559423,248845,667995,984434,716688,897964,253860,471060,834383,80400,653895,533555,579012,379418,459646,998008,542780,203081,380860,33151,87379,949685,187963,511797,155597,352282,190265,1014575,683680,47489,160381,779362,538852,691392,877483,590916,44256,675832,246506,59973,280664,615741,34039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28139 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28139 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]