SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598591 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598591 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52243,975331,657748,94905,389975,230781,685705,1013689,854320,977344,734399,830303,112958,920856,569750,728041,382963,30161,173262,150635,335824,848430,872175,149277,844578,950309,477119,1020259,882085,463523,451687,218952,540450,354761,268707,157114,795664,60230,523816,808773,172186,339659,663475,140669,535813,49023,863720,865250,91256,120594,261396,925641,559009,579173,320307,951486,268524,16669,560066,764962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]