SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022899 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022899 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673912,261418,202895,855146,507189,306459,830351,411388,390278,842185,456752,450226,915896,670776,73106,808932,194538,689288,262889,619589,763922,1004007,585599,430572,120226,285565,330856,851353,419314,800439,467946,405831,457661,774678,743433,123960,528147,994553,299947,652531,897711,1005699,342138,744276,129871,391327,953180,789581,229251,260050,472248,847428,687906,661465,934218,674864,819268,453684,389822,692573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]