SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 792010 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 792010 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974033,733302,390547,935924,650683,587881,538309,566511,131814,977858,2933,783609,485070,596699,554066,569610,872569,803970,558704,223223,437719,645768,894204,238179,494885,770439,222030,412497,843707,105604,229963,583358,345073,1029978,87660,685218,914573,117762,416553,754499,704978,1033940,1178,318900,737777,690656,284524,457319,203293,517760,52269,1002423,1004297,1020433,970138,166170,243772,892195,176398,1022047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 792010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 792010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]