SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400671 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400671 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (469804,714532,875988,866254,238933,268320,757492,760593,940803,507916,169978,876291,224955,820054,790382,551836,760825,5521,593044,769630,585542,973025,217745,944665,732758,23828,368165,332226,709430,1025980,305355,408048,270769,840314,304307,1014742,794998,437664,617491,878742,991107,243867,739267,419611,614453,617962,741599,305472,199616,760033,701357,99544,773900,599798,329568,862881,444177,427968,5705,32540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003635s ]