SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529097 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529097 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399575,1015696,875565,637040,1016012,588744,32809,510097,98296,947174,1016745,972565,315015,297609,168196,167238,472998,844869,1020724,299767,385293,747280,983482,216117,66257,14620,942260,455125,177409,393727,935098,538025,543547,594415,279414,576047,926179,775367,667597,374322,487605,534537,307299,626101,731879,844069,825800,332121,981786,324397,818555,579743,1031681,435966,578732,528942,624806,328586,981992,1023034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]