SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442089 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442089 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597095,60806,74093,68065,773844,227665,109154,803455,554076,363441,927821,60090,811674,35369,997800,24940,414622,34155,269225,169906,239269,82681,383315,355905,343097,643029,287303,1025695,1039537,104205,116172,304709,855123,586349,292842,448429,546281,347207,888408,48910,883415,413829,18545,590929,232903,702796,58385,505195,256003,570265,508847,104648,34461,492088,658733,658568,671175,223444,56471,22089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001818s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000800s ]