SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 346407 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 346407 [ RunTime:0.002748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (154812,110003,143088,906316,57634,697188,713566,764028,103083,765343,205060,681852,398841,1021584,635139,763122,621588,704399,572747,584143,95163,411305,956505,30617,236274,323578,384001,464708,268832,6198,394347,946362,70469,260343,431560,869541,522629,564004,500813,357115,643552,178110,14098,954467,971388,108164,901892,381999,288993,35965,986778,1031443,424194,996875,592180,737834,87052,385051,172096,769950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 346407 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 346407 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]