SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591529 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591529 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89391,976085,327935,269294,539757,182323,814238,3587,221254,1048385,248826,1026292,883988,482878,744996,606260,248412,553864,247640,42731,795709,295398,881005,968677,1015933,407682,663144,980346,385706,1039562,854096,990568,419537,168381,494753,42581,191567,203424,1041658,445895,513507,575768,896798,25741,237544,534493,759938,556633,780418,252844,724947,686545,432707,706640,556329,140622,772907,906011,808464,482001) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591529 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591529 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]