SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417520 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417520 [ RunTime:0.001657s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383110,197345,800495,590361,36255,515787,145250,829022,262213,181672,807218,659063,840633,868694,988677,817539,682561,1027362,183300,392908,770187,566798,473827,691405,455323,819880,519761,174348,815573,775227,635933,200537,940491,619319,800939,463744,374832,225484,858263,488051,403820,920347,668980,260488,335463,548819,639735,308431,549038,432185,113134,684489,10679,638458,142500,321182,15367,228735,607485,689839) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]