SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001602s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418109 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418109 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920222,406437,288926,705118,1031832,1036669,6213,612190,79326,100903,1048664,633277,242813,930745,848048,894171,151017,1018750,914079,507793,261102,229282,990389,973636,753916,794751,928961,155848,396764,508666,153232,166441,548913,81353,299594,598946,795318,924856,709928,779471,875897,775294,709403,247059,484543,613501,37913,880068,759262,970718,1022251,947352,512800,8796,547849,341605,111245,412145,332048,10925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001333s ]