SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53202 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53202 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258673,586728,946765,120080,586561,676943,25945,416186,373154,957526,116443,941303,1038395,929351,532806,233221,768067,68099,376336,694918,419803,433829,583627,1000581,56361,39409,754762,816811,428618,507937,242217,253099,695809,148972,781047,590662,767079,951735,220251,632399,327726,667267,917182,168401,1011188,284456,483584,55704,582682,54934,968157,956196,293622,629860,435136,644680,694652,591458,253461,261681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000374s ]