SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031160 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031160 [ RunTime:0.001884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292138,206645,443530,180044,623541,349861,253576,795934,1019828,178164,924241,79731,892485,20513,522660,445779,674284,361679,772068,669920,81314,82086,24746,339089,414094,391146,109116,371254,185109,145317,1031113,899978,393038,644698,235824,557956,303551,650460,590536,977626,363783,485683,452643,870846,249788,841112,730517,409466,923117,646600,909048,517252,784892,917924,628578,382954,903441,101544,242687,693049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000902s ]