SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538902 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538902 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312627,882766,893295,850,185219,650623,994838,63375,107684,990010,488983,598524,965946,453567,447921,25222,662516,964131,370693,3472,485572,1040269,360177,143940,911125,854814,971688,251641,777365,907491,957392,203114,151577,993451,153223,740002,113966,499677,329021,802214,238302,824676,101109,801329,612142,774819,468804,131938,311058,835413,1006317,464619,1028828,279456,635268,764945,827229,746521,263744,272401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]