SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41080 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41080 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266535,136735,687658,252975,257069,802835,227450,796954,248939,225143,112433,106263,337626,264081,373689,410042,63682,287454,323193,308341,246059,276487,757860,692691,262314,108621,421383,616601,78801,783381,344265,686486,188482,728929,467235,587659,185812,864452,152682,45837,650836,730831,764043,983430,673953,747132,333446,333784,143473,1018458,991332,238913,1041997,636572,232747,1034348,137823,473682,2383,625024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]