SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038732 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038732 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281573,508492,411759,300191,922756,570932,181700,988932,145390,235533,68262,543088,129717,748884,808524,443017,493429,1027893,357330,343957,1015073,969260,196062,829101,994428,240260,902014,258279,1008606,822048,498506,976944,979124,341271,261777,265223,360909,126040,583300,771895,22187,24394,987729,703132,249770,296169,444443,358297,915239,619335,731576,755600,558863,369348,437808,101083,767776,462077,875841,648728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038732 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038732 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]