SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002010s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591597 LIMIT 1 [ RunTime:0.000851s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591597 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651991,429473,445209,58106,637912,111678,48213,544089,881617,821788,51272,883354,615009,726021,130486,551460,714807,206828,941643,978336,100715,953908,334159,750468,545429,256527,560953,455626,96441,112954,217937,410069,148496,318256,65461,110698,783022,583183,994175,159300,258923,467811,112819,386145,350519,583867,750466,312001,999843,847646,497822,98603,518874,577175,233314,679963,66012,696709,488448,565932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591597 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591597 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]