SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506934 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506934 [ RunTime:0.002584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366287,750587,264283,765302,402408,468759,481472,263308,368595,774459,287639,486158,505903,199061,862191,135767,169594,352728,117177,580990,685166,131541,576834,819608,991545,14993,796292,906082,2150,882896,842232,164427,369785,205,359046,756784,326284,47172,977873,849696,894030,175842,609179,752506,573526,231060,199010,1043746,265700,581468,206977,736965,313413,391385,435669,59181,189113,522101,335679,914925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001708s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506934 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506934 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]