SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016514 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016514 [ RunTime:0.004479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (979774,563402,261168,980647,171093,413751,897862,505007,548327,1011298,1039162,317177,422232,424974,198193,151990,168042,312839,710229,405307,661635,1020566,1032705,717615,842546,239528,641381,938499,248496,636563,773068,403019,153136,465776,171650,799311,697108,231873,351581,235568,401422,879049,155176,602546,471342,67800,566793,81125,91792,235683,440923,364667,800827,633622,357377,699123,589884,66696,722853,899394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016514 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016514 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]