SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514099 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514099 [ RunTime:0.002199s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990653,371581,60701,894712,166828,588782,661659,892813,508576,453221,987316,27822,545139,915826,268312,238160,850760,748112,412965,802276,999718,881957,504644,984134,621825,683060,1018196,701145,774986,541194,606768,760632,923377,36401,603364,305886,599444,84042,108308,9285,13874,925664,288521,457580,771030,98684,709177,457944,312941,558970,579128,271679,684386,157170,789710,519688,756122,799849,40828,25596) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000678s ]