SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027078 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027078 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257014,988554,182656,578877,914663,191293,365308,848949,442756,730577,801513,1002842,972988,478120,768913,291378,379897,679104,422624,375503,788999,719000,226077,595045,51479,707204,381504,216393,1027720,328987,6867,55614,758797,893231,741988,883094,179314,912343,686425,632463,800144,361685,56253,885399,440445,832503,538224,907031,399300,354874,295126,46973,915505,117196,20553,506955,728445,300830,339246,22837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000428s ]