SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481373 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481373 [ RunTime:0.002221s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700327,495301,187081,326664,904106,561077,95975,256859,659666,860976,969612,665502,851661,560551,391368,875259,273046,880503,872934,311890,490387,244111,412836,391712,963336,364928,46977,876442,813425,211286,46710,604148,992719,847158,138371,617836,481553,980077,547827,559913,786684,961742,447082,888402,1043128,205576,931343,771696,472382,509760,214327,216145,43780,752698,938133,225086,844444,620266,897140,448628) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481373 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481373 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]