SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105412 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105412 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455358,738049,101171,665746,201800,879726,781826,192116,53625,753077,578919,923471,472249,7716,967614,494166,849598,171018,130029,777661,968001,121765,40074,664854,678947,464038,27419,95014,950631,637687,869507,161329,795879,701925,613697,244163,224029,249103,881107,34277,834914,314259,1014704,959677,886425,214654,118057,790040,779293,171334,823759,183404,176491,387170,221287,117286,406801,902368,196621,842812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004890s ]