SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367812 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367812 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (73522,25682,212454,153225,726125,618147,231601,1002919,786418,43784,980637,836135,36655,74552,856608,680519,1022990,622375,520751,377738,290967,803065,65729,518098,817495,6341,930447,943123,670423,43617,865397,149369,889876,53306,854846,484783,690750,540139,511666,1027773,902822,31356,581217,503474,11117,848437,22187,853131,629647,423517,919051,425702,415484,514886,276618,850207,947941,487690,27478,395546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]