SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426063 LIMIT 1 [ RunTime:0.000579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426063 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901774,676960,636104,580628,357146,325846,104486,905639,751329,675470,991615,960900,70565,966024,1045546,432806,605609,455370,239147,564040,859117,132365,582170,558607,469997,981598,813403,685663,943924,483210,654409,498306,145037,405239,341877,671877,873998,852611,402817,46133,473169,314430,63844,892746,824156,384542,694221,1020938,629056,663432,786245,894858,616205,577808,234046,520860,139997,137516,349313,99641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]