SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417384 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417384 [ RunTime:0.002305s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80966,1041108,278593,281155,7613,227384,910439,432338,794787,846899,361551,36474,58414,522496,960237,601449,415146,1003697,161985,908733,136281,726693,974555,870605,181786,339001,1022387,8376,798206,1039525,797742,283023,992584,314336,784351,192954,413424,793352,948029,946222,312645,235661,330326,441287,426244,978904,153521,712007,830614,497385,679996,569370,336160,438790,484142,269940,725584,867182,798189,311143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417384 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417384 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001037s ]