SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506841 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506841 [ RunTime:0.002963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88481,485063,162893,952394,208852,357792,789585,814173,456950,6516,789815,267951,910979,949180,453395,86983,61314,205442,578031,494243,735770,865010,96105,99109,217864,264700,703736,884563,112860,377219,386211,1044150,463048,73169,829940,537728,506078,634066,924509,426128,465534,209846,174892,305755,704116,71276,226394,331908,86560,596522,377784,690768,119616,509827,691608,509936,549038,856731,19031,204896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]