SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515243 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515243 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347505,758950,474979,835569,320024,521858,771862,80837,53720,792830,200652,391080,430963,194058,167181,884453,615458,690390,166172,458758,652967,479740,282621,793447,484785,484358,412940,1036256,122006,1011090,717671,690749,255897,1017446,351965,728632,521093,486531,698836,382060,862138,3583,65790,434153,485392,120571,484921,94848,493674,341002,585423,234339,354006,800689,140482,722091,178145,123429,750853,577266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002713s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]