SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028107 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028107 [ RunTime:0.002243s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285774,1003375,483540,374079,706347,508381,984040,319960,1005474,452803,1020491,16732,208176,1007040,157447,192732,934941,626432,799543,704327,835348,90323,332972,1004379,477707,1002578,1021423,892744,977824,317996,186077,615593,1016798,506035,666536,225557,314618,788814,664239,121499,747558,262846,476636,972976,881624,388925,934969,880108,746120,245807,625040,249602,701037,690087,355971,294651,553079,522235,640240,232395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]