SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1037554 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1037554 [ RunTime:0.001902s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118877,785455,284170,219530,285781,519739,873503,475026,426857,492422,261629,400941,823211,938139,795427,681113,138055,391004,472136,757251,781012,291067,564337,578838,586292,178336,917947,731647,160125,327723,630123,56546,147898,717446,980134,712796,313805,367062,796058,41748,356208,557110,152740,756322,10925,841629,661841,163958,87147,558977,935776,896206,709566,803325,153354,835665,235170,915037,423440,489418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1037554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1037554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]