SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 431822 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 431822 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53133,656551,351399,179002,982754,7362,544413,1013330,530924,399044,780687,101654,57179,533134,260810,123057,143492,764890,776459,162172,347025,731941,781562,1019935,505541,8518,692188,575037,300917,564856,1016434,939837,574672,939150,539824,624482,318816,543772,6227,408329,154886,290668,871382,571548,443252,1030579,766946,866151,113983,107170,181783,367219,691684,266879,600695,365956,392286,319236,999903,290428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 431822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 431822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000896s ]