SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042644 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042644 [ RunTime:0.002231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639558,108601,96680,1037542,370762,7389,725496,502456,641139,702878,873263,141977,667434,959910,63708,1030639,731116,923423,440597,98271,806686,766244,824053,360068,662576,995753,461850,1026787,680390,67554,29726,71458,547113,515055,245752,8374,657582,475675,902652,207750,1026732,923294,181962,475609,472099,953394,503304,606113,740469,157435,172664,848322,957974,619909,968469,152525,362122,253790,629113,22413) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]