SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039153 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039153 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776872,502564,161692,137675,546317,898389,394589,185877,200503,387244,241185,988157,6010,219968,592412,406798,899780,618937,324457,648817,979438,340936,299148,840113,319945,145660,201604,842509,626800,302671,332192,307050,900415,909264,671533,252683,147165,811915,866506,461746,239928,962425,237108,140970,318155,311304,918940,172373,796959,327979,681785,597400,270306,731618,358355,99577,595456,190811,769298,242315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039153 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039153 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]