SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017892 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017892 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823454,140388,63571,229217,596077,65487,530132,594735,180268,122824,420393,304612,164797,652153,747028,382377,408304,98620,107318,47860,325023,302931,535503,711919,132566,625706,522702,799663,275006,355565,266360,880638,337140,442141,103929,926499,81615,515435,427627,265641,850594,129879,518532,632429,365930,707880,511151,594441,184820,477012,753456,784244,717975,192188,537515,545321,563400,825922,289078,100961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001415s ]