SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042427 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042427 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113431,542986,494383,825103,687304,483393,20039,1036112,431014,540000,1044152,974783,559745,315019,344760,344859,490656,356502,818304,431390,1043388,444658,456949,883996,376746,3887,771427,560147,341982,892358,1008823,544834,734766,798599,125571,1023137,457671,1036748,216764,321395,830997,708467,935452,519781,632685,655836,615462,898915,850100,94988,725039,362826,184188,563929,806225,709866,163823,545901,694841,586469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]