SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504788 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504788 [ RunTime:0.002722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039149,376300,705341,917949,981141,737630,31645,596372,218712,857554,478229,284722,888308,5428,917922,927329,642032,487887,862288,728581,199978,920263,177838,79964,343186,125205,259835,985082,55924,795533,441352,438473,282647,410322,467791,934422,421216,379845,549159,934364,183002,812803,519172,1000550,655089,684142,838400,152681,917484,150386,251487,499712,668593,383278,1020485,469027,593685,1046837,933021,600799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504788 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504788 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002894s ]