SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003938s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012565 LIMIT 1 [ RunTime:0.001120s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012565 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (560139,445568,703470,699132,352804,452051,69695,1005430,522720,1007582,773295,900388,527873,406471,243754,202005,628805,926807,630015,468306,678781,984496,40574,72648,515203,49340,1010848,738150,480827,757571,232628,913754,546875,1023948,205547,847195,647580,2915,945146,199820,211474,755468,98401,733705,214560,291365,314600,367565,370133,647107,892475,996350,405730,339079,403261,980393,661935,762475,768567,1025116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012565 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012565 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]