SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39203 LIMIT 1 [ RunTime:0.001050s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39203 [ RunTime:0.004264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (489715,901639,133067,198897,662738,800621,772231,29328,679257,971977,774708,1029938,854672,68679,719431,384505,544636,1003613,336938,517603,319013,159,275170,207254,783882,755230,548075,887800,555477,166139,579229,545838,477049,142474,231363,625665,262729,21032,955914,736533,862059,453104,192457,654669,749304,815353,4985,891829,600949,220174,434955,645635,567637,558252,729109,381760,337141,144279,110189,400916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004443s ]