SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012793 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012793 [ RunTime:0.006612s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (966601,721124,918162,234038,875420,98466,1010281,474704,963324,442025,306040,807046,463942,28583,774704,948209,466521,253867,946590,486531,572367,484301,590156,278609,951201,1043866,803685,446334,567991,917308,980181,708729,527485,799867,445138,769738,673641,402534,741779,397738,920088,624356,984253,271144,630354,851452,605149,151754,84907,4882,858287,120178,871834,682724,559958,99397,850384,197571,92197,820386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012793 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012793 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]