SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101978 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101978 [ RunTime:0.003277s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344444,562702,591520,140813,838537,61366,646905,432251,664812,788349,924617,1001922,328335,528611,480264,338907,179453,303232,749853,404779,905309,552520,520912,902127,958636,78216,988181,763502,897994,708111,726695,719169,234488,364476,938224,335321,721404,569160,890131,624293,283782,191438,963361,626431,173757,911021,472323,955028,477355,974400,1045599,30846,966076,52370,775542,8235,621554,1007099,12504,407984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]