SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001480s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261018 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261018 [ RunTime:0.002613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425163,198359,924232,121810,229342,601904,971629,590200,500184,398619,769059,535722,163447,449709,517779,973051,678794,62556,405113,310035,828677,582398,776040,946169,1025897,310097,73077,234789,826134,874486,504008,354910,969443,730019,862239,183564,201340,747850,333583,127615,918054,343323,718836,871295,653617,413038,504657,859418,137762,658868,359530,952659,753537,370055,175101,430229,931340,704375,586982,435995) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]