SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501363 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501363 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (901741,376644,303042,124450,730475,605058,332246,1015212,912164,160560,587101,114413,618430,260088,74853,186945,1016174,286273,531318,84854,538303,737536,770690,916130,729594,733233,695862,261281,423359,86490,27018,420689,60198,287771,218759,77050,579032,284841,125250,738603,978032,74301,223094,376481,323956,761547,611711,186517,801819,275779,202856,553506,753378,1002569,644878,310655,987774,53472,674413,309568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501363 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501363 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]