SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447798 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447798 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249397,807026,757847,173632,861209,390832,160188,82461,713891,827639,90864,561483,768678,469690,279404,969729,391509,727197,793668,580970,97993,575076,192888,404162,997897,756060,1035222,614038,1042660,135914,207838,193468,406673,250469,292592,163140,579744,635108,1044219,681041,470355,431357,743000,798833,717837,131753,512141,58605,989317,366352,776532,234549,478107,441220,892080,155671,184122,862855,788233,1001027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]