SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532280 LIMIT 1 [ RunTime:0.000466s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532280 [ RunTime:0.007659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040451,366440,566769,224973,815668,92142,499669,1046196,405718,101934,551882,558329,426656,597756,999159,1045681,554058,198112,860788,523160,950297,1044871,1002737,657930,115201,168511,872987,486461,722662,1040499,217646,144557,9351,376232,448079,146972,591878,11378,107935,321232,348687,793858,804910,487721,966765,389782,174618,896917,1009179,825538,975188,282412,749589,233902,380302,458759,159214,730864,458958,961520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]