SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001682s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400811 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400811 [ RunTime:0.002870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515421,807278,784960,1026015,832474,605054,154866,365626,878542,670105,205790,724777,742868,275982,314962,362215,112953,79211,647984,119567,598757,463254,915926,260267,410828,114528,302983,891081,1019162,714632,713179,307287,811763,511642,1019826,341242,273241,1027501,292324,978100,624516,269218,881596,698466,795682,432288,74531,675609,614058,326504,230915,161652,36957,265589,793322,736003,61278,407684,579085,515660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001160s ]