SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971592 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971592 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328923,902483,440805,759903,207801,693081,108042,177239,668308,467892,312847,39773,149594,406158,522430,916962,539034,935168,28072,210177,275984,513300,100417,511627,1022465,575631,211506,422424,169147,508097,174228,127408,387152,39635,300701,598543,295947,441142,990246,953189,338409,177467,65872,420743,196019,104000,1045010,792578,180511,343907,811559,317978,426625,453758,905277,239112,853458,39335,304315,118989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971592 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971592 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]