SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046437 LIMIT 1 [ RunTime:0.001056s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046437 [ RunTime:0.004400s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423930,446402,343478,990811,789850,848100,486545,564128,613830,157752,82362,323937,55865,904081,612047,110345,826809,454830,71623,1007283,98436,957755,344098,953514,276354,835505,264699,932687,1023509,461660,383530,378356,846946,57442,733191,317131,943738,595946,372103,960356,78741,548069,451273,472371,474306,546466,301482,625488,476132,12806,56451,597548,462662,437139,380765,930797,724111,118380,830344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003785s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001820s ]