SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039580 LIMIT 1 [ RunTime:0.003414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039580 [ RunTime:0.005495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (30019,195511,920969,757176,785826,604500,596299,360693,471019,104187,422488,798867,559716,358365,96220,243528,462837,448035,1016682,346931,906931,673102,550337,651002,14667,992941,738617,282430,955338,194459,633553,315077,807116,576234,259929,443471,996726,321383,101198,441346,540391,390139,1021676,465771,658500,353004,395428,816366,506671,1682,18198,641630,473736,580765,78912,623415,853194,377216,282457,770805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]